package com.yanqu.road.dataHelper.action.excel;

import com.yanqu.road.dataHelper.gameServer.GameServer;
import com.yanqu.road.dataHelper.manager.ActivityMgr;
import com.yanqu.road.dataHelper.manager.BaseMgr;
import com.yanqu.road.dataHelper.manager.DataMgr;
import com.yanqu.road.dataHelper.repair.BaseRepair;
import com.yanqu.road.entity.activity.ActivityInfo;

import java.sql.CallableStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import java.util.concurrent.ConcurrentHashMap;

/**
 * @Author xx
 * @Date 2020/11/11
 */
public class Recharge extends BaseRepair {

    public Recharge(GameServer gameServer) {
        super(gameServer);
    }

    @Override
    public void repair(long param1, String param2) {

    }

    public void go(){
        List<Map<String,String>> listMap = getData();
        DataMgr.addData(listMap);
        int row = dealData();
        System.err.println(getGameServer().getServerInfo().getServerId()+":"+"更行了"+row);
    }

    private List<Map<String, String>> getData() {
        List<Map<String, String>> dataList = new ArrayList<>();
        ResultSet rs = null;
        CallableStatement call = null;
        String sql = "SELECT userId,sdkOrderNo,amount,orderStatus  FROM t_u_recharge_detail " +
                " WHERE sdkOrderNo in ('10086','skn20210501113120252276392','skn20210501114344042421012','skn20210501114421904676795','skn20210501114924242685189','skn20210501115320073862409','skn20210501120548398523362','skn20210501121510737818170','skn20210501121526340231722','skn20210501121726528018397','skn20210501121814233739639','skn20210501122917018038244','skn20210501123754681913768','skn20210501123834626645534','skn20210501124723747746821','skn20210501124843879232279','skn20210501125242436336090','skn20210501125253854510451','skn20210501125318237281733','skn20210501125328220917205','skn20210501125336941345414','skn20210501125455343751890','skn20210501125503329248349','skn20210501125513566430049','skn20210501125522365937305','skn20210501125711133225259','skn20210501132805110926308','skn20210501132823585007956','skn20210501132841341044952','skn20210501133845672349089','skn20210501133905097234391','skn20210501133914865254365','skn20210501133923534035402','skn20210501133933063112322','skn20210501133941648067442','skn20210501133949090463850','skn20210501134013864199016','skn20210501134027362268191','skn20210501134037102855266','skn20210501134045270475495','skn20210501134053547637624','skn20210501134127854353376','skn20210501134136453685287','skn20210501134424238623879','skn20210501134432292445884','skn20210501134445972460908','skn20210501134501491635347','skn20210501134539890922798','skn20210501135000224966199','skn20210501140246823491489','skn20210501140301183473726','skn20210501140316561820916','skn20210501140334415997028','skn20210501140451787845842','skn20210501140801574763019','skn20210501140802794243194','skn20210501141041005841336','skn20210501141119563628296','skn20210501141330660556132','skn20210501141353172666497','skn20210501141516588510262','skn20210501141516877074840','skn20210501141528913333669','skn20210501141606750125957','skn20210501141706566434892','skn20210501141736634237086','skn20210501141745457053542','skn20210501141754070049104','skn20210501141930904116525','skn20210501141939732251836','skn20210501141955229175853','skn20210501141957118583007','skn20210501142002974139468','skn20210501142017987884989','skn20210501142300709238658','skn20210501142809105410358','skn20210501143407110291254','skn20210501143526129650288','skn20210501143929356950982','skn20210501143937489245949','skn20210501144010786229454','skn20210501144020651941510','skn20210501144030423642249','skn20210501144038489670109','skn20210501144105176478766','skn20210501144114078947406','skn20210501144122050758525','skn20210501145006152800343','skn20210501145947386449646','skn20210501150013956248928','skn20210501150341024481046','skn20210501150353275299760','skn20210501150405629742348','skn20210501150421813086594','skn20210501150539775032666','skn20210501150615258083999','skn20210501151044949834050','skn20210501151533234504046','skn20210501151545924948553','skn20210501151705316459171','skn20210501151909188284695','skn20210501154819191029950','skn20210501154827809948730','skn20210501154837356813035','skn20210501155219040830611','skn20210501155227931972802','skn20210501155236113262667','skn20210501155244280411993','skn20210501155252744800322','skn20210501161125185162523','skn20210501163546365345624','skn20210501163555573402547','skn20210501163931295743601','skn20210501164241756375583','skn20210501164929702742428','skn20210501165201912835403','skn20210501170133720384384','skn20210501170426223830563','skn20210501170505648432771','skn20210501170537443613270','skn20210501170712781068741','skn20210501171038684471316','skn20210501172141925300162','skn20210501174512482649434','skn20210501174937558017941','skn20210501175341607051258','skn20210501175350038492847','skn20210501180851531692174','skn20210501181025076328607','skn20210501181034347144166','skn20210501181116692290170','skn20210501181422531994296','skn20210501181430719231423','skn20210501181538109696678','skn20210501183010188876244','skn20210501183700776196069','skn20210501183757333013666','skn20210501183805715668856','skn20210501184342685542475','skn20210501184442530470038','skn20210501185056647905751','skn20210501191320869157258','skn20210501191951860690450','skn20210501205207620237026','skn20210501205527596176421','skn20210501210016562611226','skn20210501210138535193504','skn20210501210345646415852','skn20210501210739658392142','skn20210501211108725893279','skn20210501211119632416977','skn20210501211126766036394','skn20210501211239798438712','skn20210501212106679945253','skn20210501212803963694822','skn20210501212951750265169','skn20210501213203878924746','skn20210501213527383051832','skn20210501213545172819073','skn20210501213601506929894','skn20210501213916369231796','skn20210501214035528712609','skn20210501214356207888562','skn20210501215621255445465','skn20210501215628528738381','skn20210501220605190660554','skn20210501220615262154942','skn20210501222053339238414','skn20210501222929471630590','skn20210501222941313479198','skn20210501223638189256201','skn20210501223658844303971','skn20210501223708128316449','skn20210501223721139294870','skn20210501223837015018199','skn20210501224012118031372','skn20210501224324401529574','skn20210501224542040614659','skn20210501224645874717170','skn20210501225005559030963','skn20210501225044508825796','skn20210501225840909005328','skn20210501231039662405464','skn20210501231148378950214','skn20210501232016584992808','skn20210501232027131069679','skn20210501232154361513988','skn20210501232208753615056','skn20210501232225073942410','skn20210501232251938141146','skn20210501232316154824983','skn20210501232607500129591','skn20210501232823906649509','skn20210501232842341712684','skn20210501232844586828921','skn20210501232915630483471','skn20210501233010708637450','skn20210501233103101529913','skn20210501233832283900322','skn20210501233841800383767','skn20210501233850245489597','skn20210501233926204646410','skn20210501234008121214768','skn20210501234041431203085','skn20210501234141097741681','skn20210501234147606037905','skn20210501234353922318605','skn20210501234527627458173','skn20210501234645238750574','skn20210501234736611994050','skn20210501234740503554130','skn20210501234816154288334','skn20210501235401124038523','skn20210502000159095394566','skn20210502000207394050581','skn20210502000944054872517','skn20210502001035966388670','skn20210502001044830305495','skn20210502001054917218961','skn20210502001126888022863','skn20210502001301382433772','skn20210502001309961058534','skn20210502001419990653290','skn20210502001430489257621','skn20210502001439970287331','skn20210502001457580307565','skn20210502001507512997910','skn20210502001520237868783','skn20210502001540288546229','skn20210502001621680905920','skn20210502001631772005958','skn20210502001720702302462','skn20210502001737803975511','skn20210502001925679771718','skn20210502001937246055372','skn20210502001948062947100','skn20210502002208481075494','skn20210502002312998435164','skn20210502002330847035453','skn20210502002340901667594','skn20210502002514651976162','skn20210502002649143230107','skn20210502002658156652309','skn20210502002708564488251','skn20210502002726418195819','skn20210502002739968106241','skn20210502002748185411251','skn20210502002902751994048','skn20210502002931964823096','skn20210502002940875953663','skn20210502002951206987619','skn20210502003115667039631','skn20210502003218888617279','skn20210502003220306227175','skn20210502003625136635206','skn20210502003856975403247','skn20210502003946329585240','skn20210502004604789652920','skn20210502004939840754139','skn20210502005101746662721','skn20210502005119178389374','skn20210502005200029966746','skn20210502005335311856684','skn20210502005413965152516','skn20210502005428574446128','skn20210502005723700250428','skn20210502010059872508167','skn20210502010552285341176','skn20210502010619365904970','skn20210502010820836034881','skn20210502012508269059967','skn20210502013046601528505','skn20210502013054896579041','skn20210502013103033785049','skn20210502013122570344371','skn20210502013556644345663','skn20210502013808067815451','skn20210502014114821107354','skn20210502014123658903754','skn20210502015635367235246','skn20210502020303481896269','skn20210502020958778197342','skn20210502021007411851670','skn20210502022139747611787','skn20210502022806840616867','skn20210502022931690014268','skn20210502023310322458630','skn20210502023338724169905','skn20210502023826737302778','skn20210502024412121413008','skn20210502024437663647940','skn20210502024524838991273','skn20210502024709739864262','skn20210502024733781577463','skn20210502024741935177031','skn20210502024914409368594','skn20210502024922775334619','skn20210502024941105764458','skn20210502025259334256279','skn20210502025308238201767','skn20210502025323129194183','skn20210502025701771660798','skn20210502025718270866158','skn20210502025945752776946','skn20210502030003090576620','skn20210502030011230441836','skn20210502030019660546297','skn20210502031328618107451','skn20210502031632769207030','skn20210502042122832154841','skn20210502042146145664108','skn20210502042152826874355','skn20210502044109148962302','skn20210502044119224058289','skn20210502044127359947948','skn20210502044136100751499','skn20210502044621440976608','skn20210502044630520136275','skn20210502044640216357557','skn20210502044649683410109','skn20210502045122706539945','skn20210502045131405257045','skn20210502045738091571746','skn20210502045806338794182','skn20210502045815127304653','skn20210502050241778830164','skn20210502050300015408764','skn20210502050935922719280','skn20210502050944685082163','skn20210502050954634557013','skn20210502051004993413099','skn20210502051046719506409','skn20210502051249430582432','skn20210502051257881522315','skn20210502051306367767888','skn20210502051315805710528','skn20210502051535785939268','skn20210502051544309462320','skn20210502051552451749169','skn20210502051601163467188','skn20210502051843162129917','skn20210502051851912207133','skn20210502051900586646517','skn20210502051908808727711','skn20210502052126052007537','skn20210502052134232738319','skn20210502052143243853928','skn20210502052149819531343','skn20210502052409412643302','skn20210502052418374257612','skn20210502052426761932456','skn20210502052435042438589','skn20210502052612742316572','skn20210502052621136994471','skn20210502052629294778002','skn20210502052637764215980','skn20210502052958729038488','skn20210502053007477595246','skn20210502053017026542800','skn20210502053025723048797','skn20210502053525753153166','skn20210502053534443204091','skn20210502053551712183598','skn20210502053702162168132','skn20210502053713686063711','skn20210502053733594784794','skn20210502053742541487237','skn20210502053943626765752','skn20210502053952238173368','skn20210502054001371421554','skn20210502054009633644697','skn20210502055104261671365','skn20210502061942886521366','skn20210502062009027560267','skn20210502062031544201343','skn20210502062226732701381','skn20210502062443652779040','skn20210502071841909498945','skn20210502072231645359226','skn20210502072344803480521','skn20210502072351467399691','skn20210502072408030738268','skn20210502072417741240514','skn20210502072625389848460','skn20210502072635137302034','skn20210502072643173813471','skn20210502072652012459171','skn20210502073414984697531','skn20210502074046472433212','skn20210502074139185796226','skn20210502074329942514982','skn20210502075443834273170','skn20210502075454231224616','skn20210502075748759807526','skn20210502091029761017353','skn20210502091045503059239','skn20210502091136757892290','skn20210502091155678338257','skn20210502091235311839978','skn20210502091244494166874','skn20210502091342224004838','skn20210502095636001359887','skn20210502095722399343324','skn20210502095731996290034','skn20210502095818669776199','skn20210502095828430890196','skn20210502095857079918039','skn20210502100802136578720','skn20210502100820555130320','skn20210502100909862299633','skn20210502101011277854028','skn20210502101052685640646','skn20210502101234504098661','skn20210502101624556826034','skn20210502101646915525352','skn20210502102152524798515','skn20210502102205294188689','skn20210502102215655563939','skn20210502102225771796725','skn20210502102232337328791','skn20210502102310405015595','skn20210502102337847962875','skn20210502102402199964615','skn20210502102411388056112','skn20210502102427569115677','skn20210502102442109028427','skn20210502102506528275332','skn20210502102531748043207','skn20210502102554181623807','skn20210502102602994104743','skn20210502102612510477875','skn20210502102645914516893','skn20210502102710515390742','skn20210502102729882323151','skn20210502102739312574902','skn20210502102751478543019','skn20210502102911848723983','skn20210502102948478182485','skn20210502102959578408103','skn20210502103012711987673','skn20210502103021473620696','skn20210502103039388960592','skn20210502103127690610426','skn20210502103136620791292','skn20210502103145630339695','skn20210502103153998752471','skn20210502103202793530674','skn20210502103211793910537','skn20210502103220657727547','skn20210502103227418088678','skn20210502103235459890043','skn20210502103252898514779','skn20210502103312706052336','skn20210502103320964616459','skn20210502103327935281227','skn20210502103336357524493','skn20210502103347588097724','skn20210502103355622379704','skn20210502103412714438708','skn20210502103430178696195','skn20210502103439408023072','skn20210502103439604733406','skn20210502103448096093384','skn20210502103448378841584','skn20210502103456827208067','skn20210502103457198909405','skn20210502103504959700499','skn20210502103513148385183','skn20210502103515437052268','skn20210502103520932460873','skn20210502103525061765723','skn20210502103538006986449','skn20210502103543792906451','skn20210502103552252185784','skn20210502103602243949054','skn20210502103618259725257','skn20210502103627247120644','skn20210502103637780323523','skn20210502103646750916096','skn20210502103656754624776','skn20210502105447625611487','skn20210502105619020384004','skn20210502105643439223448','skn20210502105658513086395','skn20210502105707051827030','skn20210502110059777645156','skn20210502110109526792698','skn20210502110222494028810','skn20210502110409078351651','skn20210502110639533793542','skn20210502110742840349824','skn20210502110804047027277','skn20210502110814445558456','skn20210502110830304955322','skn20210502111039299111019','skn20210502111145831700306','skn20210502111525519508446','skn20210502111655048993763','skn20210502112040686713555','skn20210502112054431448854','skn20210502112127801243202','skn20210502112551369952968','skn20210502114856385672448','skn20210502114914762987694','skn20210502114924427321885','skn20210502114932429324067','skn20210502114941169695275','skn20210502114949893930520','skn20210502115000599680122','skn20210502115010557316929','skn20210502115019085798412','skn20210502115033494074196','skn20210502115042635189151','skn20210502115547500303569','skn20210502115615602089158','skn20210502115624274899055','skn20210502115810398722200','skn20210502120022629501635','skn20210502120031149787180','skn20210502120039365450430','skn20210502120047509490693','skn20210502122231879333923','skn20210502122240139235014','skn20210502122248691949789','skn20210502122257089720366','skn20210502122426671594785','skn20210502122439421950368','skn20210502122456566258396','skn20210502122505073229224','skn20210502122513722706381','skn20210502122522861827803','skn20210502122618042418486','skn20210502122634918420305','skn20210502122645795640801','skn20210502122657625654967','skn20210502122708482705278','skn20210502122717732773834','skn20210502124057539210500','skn20210502124119591348569','skn20210502124157281121004','skn20210502124212213896989','skn20210502124334122967097','skn20210502124349620730738','skn20210502125722424179561','skn20210502130042907432130','skn20210502130235247507519','skn20210502130502674851031','skn20210502130556841208724','skn20210502130752225116900','skn20210502130855923855923','skn20210502131008671825212','skn20210502131150284655555','skn20210502131258556962697','skn20210502131544696866503','skn20210502131611263140873','skn20210502131619619661748','skn20210502131745391376242','skn20210502132056181818815','skn20210502133506643024912','skn20210502133518635601427','skn20210502133759254969693','skn20210502133819017536334','skn20210502133921749100868','skn20210502134042434429164','skn20210502134117992187390','skn20210502134127199408011','skn20210502134314249998000','skn20210502134351402411489','skn20210502134624391808444','skn20210502134722972498617','skn20210502135834834600448','skn20210502140001148135871','skn20210502140009839119662','skn20210502141726883516719','skn20210502141743678583440','skn20210502142022130534664','skn20210502142431379890368','skn20210502142448520958854','skn20210502142458725822075','skn20210502143228847826761','skn20210502143240608462888','skn20210502143252721488232','skn20210502143301837754167','skn20210502143314127034064','skn20210502143324506232158','skn20210502143356690160072','skn20210502143431173001212','skn20210502144603241752802','skn20210502144613116423260','skn20210502144708903670909','skn20210502144730747504358','skn20210502144855177849877','skn20210502144905402188995','skn20210502144957788958025','skn20210502151333947428706','skn20210502151622391937559','skn20210502151648166068903','skn20210502151937189064443','skn20210502152033688432464','skn20210502152316137757031','skn20210502152347061176745','skn20210502152419215419359','skn20210502152452373878856','skn20210502152509597826057','skn20210502152606827159571','skn20210502152639377090148','skn20210502152738420183988','skn20210502152750986692556','skn20210502152802199067745','skn20210502152805205301315','skn20210502152812432276930','skn20210502152832361362531','skn20210502152847246279972','skn20210502152904723304023','skn20210502152915977844277','skn20210502153056252244730','skn20210502153232992607561','skn20210502153244105776138','skn20210502153430471114882','skn20210502153828081411215','skn20210502153838333620693','skn20210502153846567773939','skn20210502153857462688200','skn20210502155659834400727','skn20210502160056432211968','skn20210502162312356871366','skn20210502162322811941208','skn20210502162333374091953','skn20210502162432137650284','skn20210502162458438712078','skn20210502162510554747114','skn20210502162557969304146','skn20210502165551203960141','skn20210502170837853048660','skn20210502170911253453359','skn20210502171133825071614','skn20210502171200635660467','skn20210502171219053123772','skn20210502171230567676710','skn20210502171241967414278','skn20210502171333846483260','skn20210502171353987684706','skn20210502171408879309166','skn20210502171439464563835','skn20210502171501898783815','skn20210502171511855829975','skn20210502171528582128390','skn20210502171542387912929','skn20210502171548305132391','skn20210502171603958434154','skn20210502171614062919267','skn20210502171627109410860','skn20210502171714524824761','skn20210502171757368424551','skn20210502171806425247889','skn20210502171829585955797','skn20210502171858720765354','skn20210502171926807853563','skn20210502171940742430097','skn20210502172111701509736','skn20210502172118165926964','skn20210502172157936441225','skn20210502172233676645612','skn20210502172242329675284','skn20210502172251270465809','skn20210502172307155603101','skn20210502172316050600382','skn20210502172326200128974','skn20210502172342423830714','skn20210502172355103246157','skn20210502172401487917560','skn20210502172444207084810','skn20210502172457746983585','skn20210502172555006252525','skn20210502172605382233397','skn20210502172630163765123','skn20210502172648057325622','skn20210502172710865813699','skn20210502172834840887405','skn20210502172855059947524','skn20210502172906236765361','skn20210502172909711898508','skn20210502172914266415173','skn20210502172918570976486','skn20210502172932964301706','skn20210502172952419342426','skn20210502172957932755906','skn20210502173017084853412','skn20210502173044172336813','skn20210502173509976773807','skn20210502173518517039785','skn20210502173527555191579','skn20210502173538756555753','skn20210502173801703489533','skn20210502173810436463655','skn20210502173950050426171','skn20210502174000237522094','skn20210502174324930296526','skn20210502174332947749700','skn20210502174347415287407','skn20210502174356544035176','skn20210502174357302152698','skn20210502174407795522484','skn20210502174416445945118','skn20210502174454251748610','skn20210502174505603665852','skn20210502174512662684260','skn20210502174540807729072','skn20210502174547776236610','skn20210502174633878204077','skn20210502174642749726584','skn20210502174727430072662','skn20210502174735973843674','skn20210502174745919393661','skn20210502174748900989875','skn20210502174808384133569','skn20210502174818001663964','skn20210502174854559098687','skn20210502174950336300999','skn20210502174959890449525','skn20210502175000118382708','skn20210502175026711801964','skn20210502175051310324219','skn20210502175102533914776','skn20210502175109472814233','skn20210502175117810036308','skn20210502175249075506493','skn20210502175255618606061','skn20210502175408528379536','skn20210502175724568796640','skn20210502175741928199667','skn20210502175757782539546','skn20210502175833674836220','skn20210502175843882983060','skn20210502175855127312316','skn20210502175903388602066','skn20210502180045741858489','skn20210502180224760169384','skn20210502180229390824541','skn20210502180238627486886','skn20210502180259997764915','skn20210502180408955054998','skn20210502180417201183334','skn20210502180441084788648','skn20210502180449306795217','skn20210502180506181879668','skn20210502180754177656054','skn20210502180843393912615','skn20210502180859440629699','skn20210502180904460127222','skn20210502180907584405524','skn20210502180915852043888','skn20210502180937866697504','skn20210502181109908192003','skn20210502181118548148897','skn20210502181124476940133','skn20210502181128427366357','skn20210502181136819183037','skn20210502181153024836223','skn20210502181224480187312','skn20210502181237980382831','skn20210502181246093794102','skn20210502181254270188879','skn20210502181307310361186','skn20210502181338556737207','skn20210502181342826389908','skn20210502181351213255307','skn20210502181355799829279','skn20210502181401832604739','skn20210502181433804460537','skn20210502181450185293281','skn20210502181533500083838','skn20210502181549129795001','skn20210502181600564130800','skn20210502181609039785723','skn20210502181625368461292','skn20210502181631686345068','skn20210502181633412747114','skn20210502181640766735838','skn20210502181649422659040','skn20210502181705255906586','skn20210502181712504621202','skn20210502181720727314318','skn20210502181734472375648','skn20210502181740786885370','skn20210502181812771130366','skn20210502181821242312884','skn20210502181829721136117','skn20210502181844974917558','skn20210502181920082249439','skn20210502181921432469344','skn20210502181934661565256','skn20210502181938035869481','skn20210502181946280215748','skn20210502181954153543360','skn20210502181955590019981','skn20210502182001239127404','skn20210502182009262673256','skn20210502182009268621565','skn20210502182036378365187','skn20210502182111446962720','skn20210502182119780931429','skn20210502182127827914643','skn20210502182136096603423','skn20210502182144125146264','skn20210502182156851013168','skn20210502182207232909988','skn20210502182216835019475','skn20210502182226408214437','skn20210502182241135342284','skn20210502182318349212133','skn20210502182323929795702','skn20210502182331565980143','skn20210502182332039560597','skn20210502182340674627801','skn20210502182346119472983','skn20210502182348758621667','skn20210502182357043735593','skn20210502182421923441767','skn20210502182436376955856','skn20210502182444930280553','skn20210502182452873969660','skn20210502182501087157103','skn20210502182513474282398','skn20210502182521642443818','skn20210502182544911834527','skn20210502182553279572059','skn20210502182559591991959','skn20210502182607806546516','skn20210502182629984378088','skn20210502182638738145336','skn20210502182646748103202','skn20210502182655281026171','skn20210502182725880077643','skn20210502182734259020902','skn20210502182739934446188','skn20210502182740877452854','skn20210502182748288837646','skn20210502182804201720942','skn20210502182830448439597','skn20210502182857834662709','skn20210502183005687776281','skn20210502183013751639993','skn20210502183018219530045','skn20210502183041449925679','skn20210502183107875320174','skn20210502183109476232130','skn20210502183146010313110','skn20210502183155575614310','skn20210502183215891971982','skn20210502183225548699999','skn20210502183237694985355','skn20210502183307536765896','skn20210502183316671230404','skn20210502183333314013190','skn20210502183345963575682','skn20210502183400992133559','skn20210502183425166151471','skn20210502183649515201149','skn20210502183721061445366','skn20210502183724045952388','skn20210502183733577406653','skn20210502183810045036594','skn20210502183821650594238','skn20210502183903410146768','skn20210502183906723316551','skn20210502183909671036393','skn20210502183911824565542','skn20210502183916500165515','skn20210502183921079177036','skn20210502183935202312496','skn20210502183946826273628','skn20210502183958082622736','skn20210502184006810060970','skn20210502184013854993581','skn20210502184023855477013','skn20210502184038881082546','skn20210502184045037318081','skn20210502184049670350358','skn20210502184053380969321','skn20210502184058559826348','skn20210502184059339073072','skn20210502184108345566508','skn20210502184112776607526','skn20210502184124614804153','skn20210502184126412606111','skn20210502184146459828074','skn20210502184152839090198','skn20210502184212415707274','skn20210502184221143342598','skn20210502184231567573858','skn20210502184236818652390','skn20210502184237094548217','skn20210502184249452593802','skn20210502184312573134279','skn20210502184320891566130','skn20210502184402419392422','skn20210502184407188835643','skn20210502184437128006902','skn20210502184445258497892','skn20210502184449774599644','skn20210502184512782763237','skn20210502184521229122450','skn20210502184552079271121','skn20210502184600301570084','skn20210502184608788609535','skn20210502184614180750633','skn20210502184646140812153','skn20210502184654685036434','skn20210502184704486065327','skn20210502184708046012172','skn20210502184711379170410','skn20210502184716513890149','skn20210502184728016567138','skn20210502184738554709049','skn20210502184745689328130','skn20210502184747616376370','skn20210502184758070384694','skn20210502184806150293876','skn20210502184809662209247','skn20210502184813724720534','skn20210502184825410897977','skn20210502184843424880346','skn20210502184906318826019','skn20210502184918986014214','skn20210502184928709993297','skn20210502184931635194069','skn20210502184936392255541','skn20210502184939901765240','skn20210502184940663134356','skn20210502184958864691901','skn20210502185021277243683','skn20210502185037827089959','skn20210502185045826848869','skn20210502185046086871821','skn20210502185051177273138','skn20210502185101304041702','skn20210502185113016735519','skn20210502185122010581584','skn20210502185122293197517','skn20210502185130587340852','skn20210502185133252816154','skn20210502185136427711073','skn20210502185142695226445','skn20210502185203716780864','skn20210502185212841172887','skn20210502185215039700724','skn20210502185220912352893','skn20210502185226584568185','skn20210502185229036662362','skn20210502185242446471132','skn20210502185250821681363','skn20210502185257929159751','skn20210502185259259999477','skn20210502185307493644704','skn20210502185310484005289','skn20210502185346239060827','skn20210502185507640422156','skn20210502185522781751467','skn20210502185712686853032','skn20210502185811912174746','skn20210502190034043455279','skn20210502190116586186853','skn20210502190120825431281','skn20210502190124499809407','skn20210502190155106493589','skn20210502190212483239356','skn20210502190220774432638','skn20210502190229038201384','skn20210502190308461144970','skn20210502190317595560842','skn20210502190326195217907','skn20210502190357604806969','skn20210502190455691918044','skn20210502190529250443954','skn20210502190608941447609','skn20210502190620744597554','skn20210502190621157178627','skn20210502190736041730784','skn20210502190743802460253','skn20210502190746352977874','skn20210502190758074864584','skn20210502190813929736212','skn20210502190826272253612','skn20210502190832067073187','skn20210502190906015435967','skn20210502190908158862122','skn20210502190910776084345','skn20210502190922806521869','skn20210502190924268951048','skn20210502191029371954401','skn20210502191208040651326','skn20210502191216053025754','skn20210502191224137378130','skn20210502191414817817105','skn20210502191446050823382','skn20210502191454415316488','skn20210502191501027221181','skn20210502191712678786769','skn20210502191730336561924','skn20210502191836424952442','skn20210502191843941972585','skn20210502191855352405520','skn20210502191945400699391','skn20210502191953563758665','skn20210502192036695555586','skn20210502192045513738286','skn20210502192342177154215','skn20210502192625413016122','skn20210502193025862336323','skn20210502193055133686859','skn20210502193302599673779','skn20210502193343044554271','skn20210502193535885490243','skn20210502194249884546429','skn20210502194258388310951','skn20210502194306275242816','skn20210502194505078745299','skn20210502194521915660084','skn20210502194842914381517')";
        try {
            call = getGameServer().getConnection().prepareCall(sql);
            int i=1;
            rs = call.executeQuery();
            while (rs.next()) {
                Map<String,String> temp = new ConcurrentHashMap<>();
                temp.put("serverId",String.valueOf(getGameServer().getServerInfo().getServerId()));
                temp.put("userId",checkNullToEmpty(rs.getString("userId")));
                temp.put("sdkOrderNo",checkNullToEmpty(rs.getString("sdkOrderNo")));
                temp.put("amount",checkNullToEmpty(rs.getString("amount")));
                temp.put("orderStatus",checkNullToEmpty(rs.getString("orderStatus")));
                dataList.add(temp);
            }
        } catch (SQLException ex) {
            getGameServer().getLogger().error("异常错误", ex);
        } finally {
            getGameServer().closeConnection(call, rs);
        }
        return dataList;
    }

    private int dealData() {
        ResultSet rs = null;
        CallableStatement call = null;
        String sql = "UPDATE t_u_recharge_detail set orderStatus = 2021051200+orderStatus" +
                " WHERE orderStatus < 10 AND sdkOrderNo in ('10086','skn20210501113120252276392','skn20210501114344042421012','skn20210501114421904676795','skn20210501114924242685189','skn20210501115320073862409','skn20210501120548398523362','skn20210501121510737818170','skn20210501121526340231722','skn20210501121726528018397','skn20210501121814233739639','skn20210501122917018038244','skn20210501123754681913768','skn20210501123834626645534','skn20210501124723747746821','skn20210501124843879232279','skn20210501125242436336090','skn20210501125253854510451','skn20210501125318237281733','skn20210501125328220917205','skn20210501125336941345414','skn20210501125455343751890','skn20210501125503329248349','skn20210501125513566430049','skn20210501125522365937305','skn20210501125711133225259','skn20210501132805110926308','skn20210501132823585007956','skn20210501132841341044952','skn20210501133845672349089','skn20210501133905097234391','skn20210501133914865254365','skn20210501133923534035402','skn20210501133933063112322','skn20210501133941648067442','skn20210501133949090463850','skn20210501134013864199016','skn20210501134027362268191','skn20210501134037102855266','skn20210501134045270475495','skn20210501134053547637624','skn20210501134127854353376','skn20210501134136453685287','skn20210501134424238623879','skn20210501134432292445884','skn20210501134445972460908','skn20210501134501491635347','skn20210501134539890922798','skn20210501135000224966199','skn20210501140246823491489','skn20210501140301183473726','skn20210501140316561820916','skn20210501140334415997028','skn20210501140451787845842','skn20210501140801574763019','skn20210501140802794243194','skn20210501141041005841336','skn20210501141119563628296','skn20210501141330660556132','skn20210501141353172666497','skn20210501141516588510262','skn20210501141516877074840','skn20210501141528913333669','skn20210501141606750125957','skn20210501141706566434892','skn20210501141736634237086','skn20210501141745457053542','skn20210501141754070049104','skn20210501141930904116525','skn20210501141939732251836','skn20210501141955229175853','skn20210501141957118583007','skn20210501142002974139468','skn20210501142017987884989','skn20210501142300709238658','skn20210501142809105410358','skn20210501143407110291254','skn20210501143526129650288','skn20210501143929356950982','skn20210501143937489245949','skn20210501144010786229454','skn20210501144020651941510','skn20210501144030423642249','skn20210501144038489670109','skn20210501144105176478766','skn20210501144114078947406','skn20210501144122050758525','skn20210501145006152800343','skn20210501145947386449646','skn20210501150013956248928','skn20210501150341024481046','skn20210501150353275299760','skn20210501150405629742348','skn20210501150421813086594','skn20210501150539775032666','skn20210501150615258083999','skn20210501151044949834050','skn20210501151533234504046','skn20210501151545924948553','skn20210501151705316459171','skn20210501151909188284695','skn20210501154819191029950','skn20210501154827809948730','skn20210501154837356813035','skn20210501155219040830611','skn20210501155227931972802','skn20210501155236113262667','skn20210501155244280411993','skn20210501155252744800322','skn20210501161125185162523','skn20210501163546365345624','skn20210501163555573402547','skn20210501163931295743601','skn20210501164241756375583','skn20210501164929702742428','skn20210501165201912835403','skn20210501170133720384384','skn20210501170426223830563','skn20210501170505648432771','skn20210501170537443613270','skn20210501170712781068741','skn20210501171038684471316','skn20210501172141925300162','skn20210501174512482649434','skn20210501174937558017941','skn20210501175341607051258','skn20210501175350038492847','skn20210501180851531692174','skn20210501181025076328607','skn20210501181034347144166','skn20210501181116692290170','skn20210501181422531994296','skn20210501181430719231423','skn20210501181538109696678','skn20210501183010188876244','skn20210501183700776196069','skn20210501183757333013666','skn20210501183805715668856','skn20210501184342685542475','skn20210501184442530470038','skn20210501185056647905751','skn20210501191320869157258','skn20210501191951860690450','skn20210501205207620237026','skn20210501205527596176421','skn20210501210016562611226','skn20210501210138535193504','skn20210501210345646415852','skn20210501210739658392142','skn20210501211108725893279','skn20210501211119632416977','skn20210501211126766036394','skn20210501211239798438712','skn20210501212106679945253','skn20210501212803963694822','skn20210501212951750265169','skn20210501213203878924746','skn20210501213527383051832','skn20210501213545172819073','skn20210501213601506929894','skn20210501213916369231796','skn20210501214035528712609','skn20210501214356207888562','skn20210501215621255445465','skn20210501215628528738381','skn20210501220605190660554','skn20210501220615262154942','skn20210501222053339238414','skn20210501222929471630590','skn20210501222941313479198','skn20210501223638189256201','skn20210501223658844303971','skn20210501223708128316449','skn20210501223721139294870','skn20210501223837015018199','skn20210501224012118031372','skn20210501224324401529574','skn20210501224542040614659','skn20210501224645874717170','skn20210501225005559030963','skn20210501225044508825796','skn20210501225840909005328','skn20210501231039662405464','skn20210501231148378950214','skn20210501232016584992808','skn20210501232027131069679','skn20210501232154361513988','skn20210501232208753615056','skn20210501232225073942410','skn20210501232251938141146','skn20210501232316154824983','skn20210501232607500129591','skn20210501232823906649509','skn20210501232842341712684','skn20210501232844586828921','skn20210501232915630483471','skn20210501233010708637450','skn20210501233103101529913','skn20210501233832283900322','skn20210501233841800383767','skn20210501233850245489597','skn20210501233926204646410','skn20210501234008121214768','skn20210501234041431203085','skn20210501234141097741681','skn20210501234147606037905','skn20210501234353922318605','skn20210501234527627458173','skn20210501234645238750574','skn20210501234736611994050','skn20210501234740503554130','skn20210501234816154288334','skn20210501235401124038523','skn20210502000159095394566','skn20210502000207394050581','skn20210502000944054872517','skn20210502001035966388670','skn20210502001044830305495','skn20210502001054917218961','skn20210502001126888022863','skn20210502001301382433772','skn20210502001309961058534','skn20210502001419990653290','skn20210502001430489257621','skn20210502001439970287331','skn20210502001457580307565','skn20210502001507512997910','skn20210502001520237868783','skn20210502001540288546229','skn20210502001621680905920','skn20210502001631772005958','skn20210502001720702302462','skn20210502001737803975511','skn20210502001925679771718','skn20210502001937246055372','skn20210502001948062947100','skn20210502002208481075494','skn20210502002312998435164','skn20210502002330847035453','skn20210502002340901667594','skn20210502002514651976162','skn20210502002649143230107','skn20210502002658156652309','skn20210502002708564488251','skn20210502002726418195819','skn20210502002739968106241','skn20210502002748185411251','skn20210502002902751994048','skn20210502002931964823096','skn20210502002940875953663','skn20210502002951206987619','skn20210502003115667039631','skn20210502003218888617279','skn20210502003220306227175','skn20210502003625136635206','skn20210502003856975403247','skn20210502003946329585240','skn20210502004604789652920','skn20210502004939840754139','skn20210502005101746662721','skn20210502005119178389374','skn20210502005200029966746','skn20210502005335311856684','skn20210502005413965152516','skn20210502005428574446128','skn20210502005723700250428','skn20210502010059872508167','skn20210502010552285341176','skn20210502010619365904970','skn20210502010820836034881','skn20210502012508269059967','skn20210502013046601528505','skn20210502013054896579041','skn20210502013103033785049','skn20210502013122570344371','skn20210502013556644345663','skn20210502013808067815451','skn20210502014114821107354','skn20210502014123658903754','skn20210502015635367235246','skn20210502020303481896269','skn20210502020958778197342','skn20210502021007411851670','skn20210502022139747611787','skn20210502022806840616867','skn20210502022931690014268','skn20210502023310322458630','skn20210502023338724169905','skn20210502023826737302778','skn20210502024412121413008','skn20210502024437663647940','skn20210502024524838991273','skn20210502024709739864262','skn20210502024733781577463','skn20210502024741935177031','skn20210502024914409368594','skn20210502024922775334619','skn20210502024941105764458','skn20210502025259334256279','skn20210502025308238201767','skn20210502025323129194183','skn20210502025701771660798','skn20210502025718270866158','skn20210502025945752776946','skn20210502030003090576620','skn20210502030011230441836','skn20210502030019660546297','skn20210502031328618107451','skn20210502031632769207030','skn20210502042122832154841','skn20210502042146145664108','skn20210502042152826874355','skn20210502044109148962302','skn20210502044119224058289','skn20210502044127359947948','skn20210502044136100751499','skn20210502044621440976608','skn20210502044630520136275','skn20210502044640216357557','skn20210502044649683410109','skn20210502045122706539945','skn20210502045131405257045','skn20210502045738091571746','skn20210502045806338794182','skn20210502045815127304653','skn20210502050241778830164','skn20210502050300015408764','skn20210502050935922719280','skn20210502050944685082163','skn20210502050954634557013','skn20210502051004993413099','skn20210502051046719506409','skn20210502051249430582432','skn20210502051257881522315','skn20210502051306367767888','skn20210502051315805710528','skn20210502051535785939268','skn20210502051544309462320','skn20210502051552451749169','skn20210502051601163467188','skn20210502051843162129917','skn20210502051851912207133','skn20210502051900586646517','skn20210502051908808727711','skn20210502052126052007537','skn20210502052134232738319','skn20210502052143243853928','skn20210502052149819531343','skn20210502052409412643302','skn20210502052418374257612','skn20210502052426761932456','skn20210502052435042438589','skn20210502052612742316572','skn20210502052621136994471','skn20210502052629294778002','skn20210502052637764215980','skn20210502052958729038488','skn20210502053007477595246','skn20210502053017026542800','skn20210502053025723048797','skn20210502053525753153166','skn20210502053534443204091','skn20210502053551712183598','skn20210502053702162168132','skn20210502053713686063711','skn20210502053733594784794','skn20210502053742541487237','skn20210502053943626765752','skn20210502053952238173368','skn20210502054001371421554','skn20210502054009633644697','skn20210502055104261671365','skn20210502061942886521366','skn20210502062009027560267','skn20210502062031544201343','skn20210502062226732701381','skn20210502062443652779040','skn20210502071841909498945','skn20210502072231645359226','skn20210502072344803480521','skn20210502072351467399691','skn20210502072408030738268','skn20210502072417741240514','skn20210502072625389848460','skn20210502072635137302034','skn20210502072643173813471','skn20210502072652012459171','skn20210502073414984697531','skn20210502074046472433212','skn20210502074139185796226','skn20210502074329942514982','skn20210502075443834273170','skn20210502075454231224616','skn20210502075748759807526','skn20210502091029761017353','skn20210502091045503059239','skn20210502091136757892290','skn20210502091155678338257','skn20210502091235311839978','skn20210502091244494166874','skn20210502091342224004838','skn20210502095636001359887','skn20210502095722399343324','skn20210502095731996290034','skn20210502095818669776199','skn20210502095828430890196','skn20210502095857079918039','skn20210502100802136578720','skn20210502100820555130320','skn20210502100909862299633','skn20210502101011277854028','skn20210502101052685640646','skn20210502101234504098661','skn20210502101624556826034','skn20210502101646915525352','skn20210502102152524798515','skn20210502102205294188689','skn20210502102215655563939','skn20210502102225771796725','skn20210502102232337328791','skn20210502102310405015595','skn20210502102337847962875','skn20210502102402199964615','skn20210502102411388056112','skn20210502102427569115677','skn20210502102442109028427','skn20210502102506528275332','skn20210502102531748043207','skn20210502102554181623807','skn20210502102602994104743','skn20210502102612510477875','skn20210502102645914516893','skn20210502102710515390742','skn20210502102729882323151','skn20210502102739312574902','skn20210502102751478543019','skn20210502102911848723983','skn20210502102948478182485','skn20210502102959578408103','skn20210502103012711987673','skn20210502103021473620696','skn20210502103039388960592','skn20210502103127690610426','skn20210502103136620791292','skn20210502103145630339695','skn20210502103153998752471','skn20210502103202793530674','skn20210502103211793910537','skn20210502103220657727547','skn20210502103227418088678','skn20210502103235459890043','skn20210502103252898514779','skn20210502103312706052336','skn20210502103320964616459','skn20210502103327935281227','skn20210502103336357524493','skn20210502103347588097724','skn20210502103355622379704','skn20210502103412714438708','skn20210502103430178696195','skn20210502103439408023072','skn20210502103439604733406','skn20210502103448096093384','skn20210502103448378841584','skn20210502103456827208067','skn20210502103457198909405','skn20210502103504959700499','skn20210502103513148385183','skn20210502103515437052268','skn20210502103520932460873','skn20210502103525061765723','skn20210502103538006986449','skn20210502103543792906451','skn20210502103552252185784','skn20210502103602243949054','skn20210502103618259725257','skn20210502103627247120644','skn20210502103637780323523','skn20210502103646750916096','skn20210502103656754624776','skn20210502105447625611487','skn20210502105619020384004','skn20210502105643439223448','skn20210502105658513086395','skn20210502105707051827030','skn20210502110059777645156','skn20210502110109526792698','skn20210502110222494028810','skn20210502110409078351651','skn20210502110639533793542','skn20210502110742840349824','skn20210502110804047027277','skn20210502110814445558456','skn20210502110830304955322','skn20210502111039299111019','skn20210502111145831700306','skn20210502111525519508446','skn20210502111655048993763','skn20210502112040686713555','skn20210502112054431448854','skn20210502112127801243202','skn20210502112551369952968','skn20210502114856385672448','skn20210502114914762987694','skn20210502114924427321885','skn20210502114932429324067','skn20210502114941169695275','skn20210502114949893930520','skn20210502115000599680122','skn20210502115010557316929','skn20210502115019085798412','skn20210502115033494074196','skn20210502115042635189151','skn20210502115547500303569','skn20210502115615602089158','skn20210502115624274899055','skn20210502115810398722200','skn20210502120022629501635','skn20210502120031149787180','skn20210502120039365450430','skn20210502120047509490693','skn20210502122231879333923','skn20210502122240139235014','skn20210502122248691949789','skn20210502122257089720366','skn20210502122426671594785','skn20210502122439421950368','skn20210502122456566258396','skn20210502122505073229224','skn20210502122513722706381','skn20210502122522861827803','skn20210502122618042418486','skn20210502122634918420305','skn20210502122645795640801','skn20210502122657625654967','skn20210502122708482705278','skn20210502122717732773834','skn20210502124057539210500','skn20210502124119591348569','skn20210502124157281121004','skn20210502124212213896989','skn20210502124334122967097','skn20210502124349620730738','skn20210502125722424179561','skn20210502130042907432130','skn20210502130235247507519','skn20210502130502674851031','skn20210502130556841208724','skn20210502130752225116900','skn20210502130855923855923','skn20210502131008671825212','skn20210502131150284655555','skn20210502131258556962697','skn20210502131544696866503','skn20210502131611263140873','skn20210502131619619661748','skn20210502131745391376242','skn20210502132056181818815','skn20210502133506643024912','skn20210502133518635601427','skn20210502133759254969693','skn20210502133819017536334','skn20210502133921749100868','skn20210502134042434429164','skn20210502134117992187390','skn20210502134127199408011','skn20210502134314249998000','skn20210502134351402411489','skn20210502134624391808444','skn20210502134722972498617','skn20210502135834834600448','skn20210502140001148135871','skn20210502140009839119662','skn20210502141726883516719','skn20210502141743678583440','skn20210502142022130534664','skn20210502142431379890368','skn20210502142448520958854','skn20210502142458725822075','skn20210502143228847826761','skn20210502143240608462888','skn20210502143252721488232','skn20210502143301837754167','skn20210502143314127034064','skn20210502143324506232158','skn20210502143356690160072','skn20210502143431173001212','skn20210502144603241752802','skn20210502144613116423260','skn20210502144708903670909','skn20210502144730747504358','skn20210502144855177849877','skn20210502144905402188995','skn20210502144957788958025','skn20210502151333947428706','skn20210502151622391937559','skn20210502151648166068903','skn20210502151937189064443','skn20210502152033688432464','skn20210502152316137757031','skn20210502152347061176745','skn20210502152419215419359','skn20210502152452373878856','skn20210502152509597826057','skn20210502152606827159571','skn20210502152639377090148','skn20210502152738420183988','skn20210502152750986692556','skn20210502152802199067745','skn20210502152805205301315','skn20210502152812432276930','skn20210502152832361362531','skn20210502152847246279972','skn20210502152904723304023','skn20210502152915977844277','skn20210502153056252244730','skn20210502153232992607561','skn20210502153244105776138','skn20210502153430471114882','skn20210502153828081411215','skn20210502153838333620693','skn20210502153846567773939','skn20210502153857462688200','skn20210502155659834400727','skn20210502160056432211968','skn20210502162312356871366','skn20210502162322811941208','skn20210502162333374091953','skn20210502162432137650284','skn20210502162458438712078','skn20210502162510554747114','skn20210502162557969304146','skn20210502165551203960141','skn20210502170837853048660','skn20210502170911253453359','skn20210502171133825071614','skn20210502171200635660467','skn20210502171219053123772','skn20210502171230567676710','skn20210502171241967414278','skn20210502171333846483260','skn20210502171353987684706','skn20210502171408879309166','skn20210502171439464563835','skn20210502171501898783815','skn20210502171511855829975','skn20210502171528582128390','skn20210502171542387912929','skn20210502171548305132391','skn20210502171603958434154','skn20210502171614062919267','skn20210502171627109410860','skn20210502171714524824761','skn20210502171757368424551','skn20210502171806425247889','skn20210502171829585955797','skn20210502171858720765354','skn20210502171926807853563','skn20210502171940742430097','skn20210502172111701509736','skn20210502172118165926964','skn20210502172157936441225','skn20210502172233676645612','skn20210502172242329675284','skn20210502172251270465809','skn20210502172307155603101','skn20210502172316050600382','skn20210502172326200128974','skn20210502172342423830714','skn20210502172355103246157','skn20210502172401487917560','skn20210502172444207084810','skn20210502172457746983585','skn20210502172555006252525','skn20210502172605382233397','skn20210502172630163765123','skn20210502172648057325622','skn20210502172710865813699','skn20210502172834840887405','skn20210502172855059947524','skn20210502172906236765361','skn20210502172909711898508','skn20210502172914266415173','skn20210502172918570976486','skn20210502172932964301706','skn20210502172952419342426','skn20210502172957932755906','skn20210502173017084853412','skn20210502173044172336813','skn20210502173509976773807','skn20210502173518517039785','skn20210502173527555191579','skn20210502173538756555753','skn20210502173801703489533','skn20210502173810436463655','skn20210502173950050426171','skn20210502174000237522094','skn20210502174324930296526','skn20210502174332947749700','skn20210502174347415287407','skn20210502174356544035176','skn20210502174357302152698','skn20210502174407795522484','skn20210502174416445945118','skn20210502174454251748610','skn20210502174505603665852','skn20210502174512662684260','skn20210502174540807729072','skn20210502174547776236610','skn20210502174633878204077','skn20210502174642749726584','skn20210502174727430072662','skn20210502174735973843674','skn20210502174745919393661','skn20210502174748900989875','skn20210502174808384133569','skn20210502174818001663964','skn20210502174854559098687','skn20210502174950336300999','skn20210502174959890449525','skn20210502175000118382708','skn20210502175026711801964','skn20210502175051310324219','skn20210502175102533914776','skn20210502175109472814233','skn20210502175117810036308','skn20210502175249075506493','skn20210502175255618606061','skn20210502175408528379536','skn20210502175724568796640','skn20210502175741928199667','skn20210502175757782539546','skn20210502175833674836220','skn20210502175843882983060','skn20210502175855127312316','skn20210502175903388602066','skn20210502180045741858489','skn20210502180224760169384','skn20210502180229390824541','skn20210502180238627486886','skn20210502180259997764915','skn20210502180408955054998','skn20210502180417201183334','skn20210502180441084788648','skn20210502180449306795217','skn20210502180506181879668','skn20210502180754177656054','skn20210502180843393912615','skn20210502180859440629699','skn20210502180904460127222','skn20210502180907584405524','skn20210502180915852043888','skn20210502180937866697504','skn20210502181109908192003','skn20210502181118548148897','skn20210502181124476940133','skn20210502181128427366357','skn20210502181136819183037','skn20210502181153024836223','skn20210502181224480187312','skn20210502181237980382831','skn20210502181246093794102','skn20210502181254270188879','skn20210502181307310361186','skn20210502181338556737207','skn20210502181342826389908','skn20210502181351213255307','skn20210502181355799829279','skn20210502181401832604739','skn20210502181433804460537','skn20210502181450185293281','skn20210502181533500083838','skn20210502181549129795001','skn20210502181600564130800','skn20210502181609039785723','skn20210502181625368461292','skn20210502181631686345068','skn20210502181633412747114','skn20210502181640766735838','skn20210502181649422659040','skn20210502181705255906586','skn20210502181712504621202','skn20210502181720727314318','skn20210502181734472375648','skn20210502181740786885370','skn20210502181812771130366','skn20210502181821242312884','skn20210502181829721136117','skn20210502181844974917558','skn20210502181920082249439','skn20210502181921432469344','skn20210502181934661565256','skn20210502181938035869481','skn20210502181946280215748','skn20210502181954153543360','skn20210502181955590019981','skn20210502182001239127404','skn20210502182009262673256','skn20210502182009268621565','skn20210502182036378365187','skn20210502182111446962720','skn20210502182119780931429','skn20210502182127827914643','skn20210502182136096603423','skn20210502182144125146264','skn20210502182156851013168','skn20210502182207232909988','skn20210502182216835019475','skn20210502182226408214437','skn20210502182241135342284','skn20210502182318349212133','skn20210502182323929795702','skn20210502182331565980143','skn20210502182332039560597','skn20210502182340674627801','skn20210502182346119472983','skn20210502182348758621667','skn20210502182357043735593','skn20210502182421923441767','skn20210502182436376955856','skn20210502182444930280553','skn20210502182452873969660','skn20210502182501087157103','skn20210502182513474282398','skn20210502182521642443818','skn20210502182544911834527','skn20210502182553279572059','skn20210502182559591991959','skn20210502182607806546516','skn20210502182629984378088','skn20210502182638738145336','skn20210502182646748103202','skn20210502182655281026171','skn20210502182725880077643','skn20210502182734259020902','skn20210502182739934446188','skn20210502182740877452854','skn20210502182748288837646','skn20210502182804201720942','skn20210502182830448439597','skn20210502182857834662709','skn20210502183005687776281','skn20210502183013751639993','skn20210502183018219530045','skn20210502183041449925679','skn20210502183107875320174','skn20210502183109476232130','skn20210502183146010313110','skn20210502183155575614310','skn20210502183215891971982','skn20210502183225548699999','skn20210502183237694985355','skn20210502183307536765896','skn20210502183316671230404','skn20210502183333314013190','skn20210502183345963575682','skn20210502183400992133559','skn20210502183425166151471','skn20210502183649515201149','skn20210502183721061445366','skn20210502183724045952388','skn20210502183733577406653','skn20210502183810045036594','skn20210502183821650594238','skn20210502183903410146768','skn20210502183906723316551','skn20210502183909671036393','skn20210502183911824565542','skn20210502183916500165515','skn20210502183921079177036','skn20210502183935202312496','skn20210502183946826273628','skn20210502183958082622736','skn20210502184006810060970','skn20210502184013854993581','skn20210502184023855477013','skn20210502184038881082546','skn20210502184045037318081','skn20210502184049670350358','skn20210502184053380969321','skn20210502184058559826348','skn20210502184059339073072','skn20210502184108345566508','skn20210502184112776607526','skn20210502184124614804153','skn20210502184126412606111','skn20210502184146459828074','skn20210502184152839090198','skn20210502184212415707274','skn20210502184221143342598','skn20210502184231567573858','skn20210502184236818652390','skn20210502184237094548217','skn20210502184249452593802','skn20210502184312573134279','skn20210502184320891566130','skn20210502184402419392422','skn20210502184407188835643','skn20210502184437128006902','skn20210502184445258497892','skn20210502184449774599644','skn20210502184512782763237','skn20210502184521229122450','skn20210502184552079271121','skn20210502184600301570084','skn20210502184608788609535','skn20210502184614180750633','skn20210502184646140812153','skn20210502184654685036434','skn20210502184704486065327','skn20210502184708046012172','skn20210502184711379170410','skn20210502184716513890149','skn20210502184728016567138','skn20210502184738554709049','skn20210502184745689328130','skn20210502184747616376370','skn20210502184758070384694','skn20210502184806150293876','skn20210502184809662209247','skn20210502184813724720534','skn20210502184825410897977','skn20210502184843424880346','skn20210502184906318826019','skn20210502184918986014214','skn20210502184928709993297','skn20210502184931635194069','skn20210502184936392255541','skn20210502184939901765240','skn20210502184940663134356','skn20210502184958864691901','skn20210502185021277243683','skn20210502185037827089959','skn20210502185045826848869','skn20210502185046086871821','skn20210502185051177273138','skn20210502185101304041702','skn20210502185113016735519','skn20210502185122010581584','skn20210502185122293197517','skn20210502185130587340852','skn20210502185133252816154','skn20210502185136427711073','skn20210502185142695226445','skn20210502185203716780864','skn20210502185212841172887','skn20210502185215039700724','skn20210502185220912352893','skn20210502185226584568185','skn20210502185229036662362','skn20210502185242446471132','skn20210502185250821681363','skn20210502185257929159751','skn20210502185259259999477','skn20210502185307493644704','skn20210502185310484005289','skn20210502185346239060827','skn20210502185507640422156','skn20210502185522781751467','skn20210502185712686853032','skn20210502185811912174746','skn20210502190034043455279','skn20210502190116586186853','skn20210502190120825431281','skn20210502190124499809407','skn20210502190155106493589','skn20210502190212483239356','skn20210502190220774432638','skn20210502190229038201384','skn20210502190308461144970','skn20210502190317595560842','skn20210502190326195217907','skn20210502190357604806969','skn20210502190455691918044','skn20210502190529250443954','skn20210502190608941447609','skn20210502190620744597554','skn20210502190621157178627','skn20210502190736041730784','skn20210502190743802460253','skn20210502190746352977874','skn20210502190758074864584','skn20210502190813929736212','skn20210502190826272253612','skn20210502190832067073187','skn20210502190906015435967','skn20210502190908158862122','skn20210502190910776084345','skn20210502190922806521869','skn20210502190924268951048','skn20210502191029371954401','skn20210502191208040651326','skn20210502191216053025754','skn20210502191224137378130','skn20210502191414817817105','skn20210502191446050823382','skn20210502191454415316488','skn20210502191501027221181','skn20210502191712678786769','skn20210502191730336561924','skn20210502191836424952442','skn20210502191843941972585','skn20210502191855352405520','skn20210502191945400699391','skn20210502191953563758665','skn20210502192036695555586','skn20210502192045513738286','skn20210502192342177154215','skn20210502192625413016122','skn20210502193025862336323','skn20210502193055133686859','skn20210502193302599673779','skn20210502193343044554271','skn20210502193535885490243','skn20210502194249884546429','skn20210502194258388310951','skn20210502194306275242816','skn20210502194505078745299','skn20210502194521915660084','skn20210502194842914381517')";
        try {
            call = getGameServer().getConnection().prepareCall(sql);
            return call.executeUpdate();
        } catch (SQLException ex) {
            getGameServer().getLogger().error("异常错误", ex);
        } finally {
            getGameServer().closeConnection(call, rs);
        }
        return 0;
    }

}
